Mega Code Archive
String Functions
1) A SELECT statement that uses the CHAR function to format output
2) A SELECT statement that uses the LEFT function
3) A SELECT statement that uses the LEFT, RIGHT, and SUBSTRING functions
4) ASCII returns the ASCII numeric value of the leftmost character of a string
5) Changing Character Values to Lower
6) Changing Character Values to Upper
7) Changing Strings to Sentence Case
8) CHAR is the reverse of the ASCII function as it changes a numeric value in to an ASCII character
9) CHAR(13)
10) CHAR(ASCIIValue)
11) CHARINDEX returns the starting point of the first occurrence of one string within another string
12) CONVERT(varchar(20), RTRIM(au_lname) + , + RTRIM(au_fname)
13) Converting a Character Value to ASCII and Back to Character
14) Converting an ASCII Value to Character
15) Determining the Number of Characters or Bytes in a String by using LEN
16) Determining the Similarity of Strings
17) DIFFERENCE function returns a value between 0 and 4 that reflects how close a match there is between the two strings
18) DIFFERENCE() is a wrapper around two SOUNDEX()
19) DIFFERENCE(Nite, Knight)
20) Finding the Start Position of a String Within Another String
21) Finding the Start Position of a String Within Another String Using Wildcards
22) FORMATMESSAGE function
23) Get Character Unicode Values
24) Get index of the delimiting space
25) Get the last name
26) use the string functions to parse a string
27) LEFT function returns a number of characters from the left-hand side of a string
28) LEFT(CompanyName, 1) and like
29) LEN Returns the length of a string as an integer
30) LOWER Translates all characters within the string to lower case
31) LTRIM Removes leading spaces from a string
32) NCHAR Returns a Unicode character representing the number passed as a parameter
33) Outputting an Expression in Reverse Order
34) Padding a number for business purposes with right
35) PATINDEX searches for a pattern of characters within a string
36) Prefixing a Numeric Value with Zeros
37) QUOTENAME function
38) QUOTENAME takes a character string and turns it in to a valid SQL Server identifier, which can be used as a name for a SQ
39) Removing Leading Blanks
40) Removing Trailing Blanks
41) Repeating a Blank Space N Times
42) Repeating an Expression N Number of Times
43) REPLACE takes three strings as parameters, and all instances of the second string in the first are replaced by the third
44) REPLICATE is used if you wish to replicate the same string several times
45) REPLICATE(A, 3)
46) Return first name
47) Returning a Chunk of an Expression
48) Returning Integer Unicode Values
49) REVERSE takes the string input, and reverses the order of the information
50) RIGHT return a number of characters from the right-hand side of a string
51) RTRIM a column
52) RTRIM will remove trailing spaces from a string
53) Select CHARINDEX(-, (559) 555-1212)
54) SELECT CHARINDEX(Mars, The stars near Mars are far from ours)
55) Select CHARINDEX(SQL, SQL Server)
56) SELECT DIFFERENCE (Redmond, Renton)
57) Select LEFT(SQL Server, 3)
58) Select LEN( SQL Server ) (space at both ends)
59) Select LEN(SQL Server)
60) Select LOWER(SQL Server)
61) Select LTRIM( SQL Server )
62) Select LTRIM(RTRIM( SQL Server ))
63) SELECT PATINDEX(%M_rs%, The stars near Mars are far from ours)
64) Select PATINDEX(%v_r%, SQL Server)
65) Select REPLACE(RIGHT((559) 555-1212, 13), ) , -)
66) Select RTRIM( SQL Server )
67) SELECT STR(1, 12, 4)
68) SELECT STR(1, 6, 4)
69) SELECT STR(123 456789, 8, 4)
70) Select SUBSTRING((559) 555-1212, 7, 8)
71) Select UPPER(ca)
72) Sound difference
73) SOUNDEX checks how similarly sounding two tested strings can be
74) SOUNDEX(Knight)
75) SPACE returns a set number of spaces
76) STR takes a numeric value and changes the data type to a char
77) STR() converts a numeric value to a string
78) STR(float_expression, character_length, number_of_decimal_places)
79) STUFF(notes, PATINDEX(%computer[^s]%, notes)
80) Stuffing a String into a String
81) SUBSTRING is used to retrieve part of a string from another string The syntax for the function is as follows
82) SUBSTRING(FullName, CHARINDEX( , FullName) + 1, LEN(FullName))
83) Substring with variable
84) Taking the Leftmost or Rightmost Part of a String
85) Taking the Rightmost Part of a String
86) The LOWER() and UPPER() Functions
87) The LTRIM() and RTRIM() Functions
88) The NCHAR() function takes a positive integer between 0 and 65,535 and returns a datatype of nchar(1) with the correspond
89) The REPLICATE() and LEN() Functions
90) The syntax for STUFF is STUFF(string_used_as_basis, start_point, length, string_to_insert)
91) UNICODE Returns the integer Unicode value of a single leftmost character in a string
92) UPPER Translates all characters within the string to upper case
93) Use DIFFERENCE in where clause
94) Use LEFT and RIGHT to get sub value from a column
95) Use SOUNDEX(au_lname) and DIFFERENCE
96) Using String Functions to Search for Phonetically Similar Data
97) WHERE PATINDEX(%computer[^s]%, notes) 0